﻿CREATE TABLE [ODData].[Coverage] (
    [ObjectID]          INT               IDENTITY (1, 1) NOT NULL,
    [SeriesID]          INT               NOT NULL,
    [LocalDateTime]     DATETIME          NOT NULL,
    [UTCOffsetHours]    REAL              NOT NULL,
    [ObservationValues] [dbo].[Coverage]  NOT NULL,
    [CoverageGeometry]  [sys].[geography] NOT NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Contains data that varies across its bounding geometry at an instance in time such as gridded data, lake temperature profiles, channel cross-sections or graphs such as rating curves.', @level0type = N'SCHEMA', @level0name = N'ODData', @level1type = N'TABLE', @level1name = N'Coverage';

